<?php

$sql = "
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 20, 2008 at 07:27 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
-- 
-- Database: `photosaic`
-- 
CREATE DATABASE `photosaic` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
USE `photosaic`;

-- --------------------------------------------------------

-- 
-- Table structure for table `photo_cache`
-- 

CREATE TABLE `photo_cache` (
  `photo_id` int(11) NOT NULL auto_increment,
  `url` varchar(128) collate latin1_general_ci NOT NULL,
  `r` int(2) NOT NULL,
  `g` int(2) NOT NULL,
  `b` int(2) NOT NULL,
  `r_match` decimal(3,2) NOT NULL,
  `g_match` decimal(3,2) NOT NULL,
  `b_match` decimal(3,2) NOT NULL,
  `rgb_match` decimal(3,2) NOT NULL,
  `added` datetime NOT NULL,
  PRIMARY KEY  (`photo_id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Stores photos for Photosaic processing.' AUTO_INCREMENT=2 ;

";

mysql_connect('localhost','root','');
mysql_query($sql);
?>